package org.gw.building.repositories.dkgg;

import org.gw.building.model.Kcxx;
import org.gw.building.model.Kqy;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

public interface KcxxRepository extends JpaRepository<Kcxx, String>{
	@Query("from Kcxx t where (?1 is null or t.qc = ?1) and (?2 is null or t.kcmc like ?2) and (?3 is null or t.kksj > ?3) order by t.kksj desc")
	Page<Kcxx> queryPage(String qc, String mc, String kksj, Pageable pageable);
}
